package com.huangpuweb.api.model;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;

public class SysConstructionProjectRowMapper implements RowMapper<SysConstructionProject>{



	@Override
	public SysConstructionProject mapRow(ResultSet rs, int rowNum) throws SQLException {
		SysConstructionProject  lj= new SysConstructionProject();
		lj.setId(rs.getInt("id"));
		lj.setNumber(rs.getString("number"));
		lj.setProject_name(rs.getString("project_name"));
		lj.setCost(rs.getString("cost"));
		lj.setStatus(rs.getString("status"));
		lj.setArea(rs.getString("area"));
		lj.setAdress(rs.getString("adress"));
		lj.setStreet(rs.getString("street"));
		lj.setFirst_roadwork_date(rs.getString("first_roadwork_date"));
		lj.setConstruction_unit(rs.getString("construction_unit"));
		lj.setRoadwork_unit(rs.getString("roadwork_unit"));
		lj.setPrincipal(rs.getString("principal"));
		lj.setPhone(rs.getString("phone"));
		lj.setArchitect(rs.getString("architect"));
		lj.setReconnaissance_unit(rs.getString("reconnaissance_unit"));
		lj.setSupervising_unit(rs.getString("supervising_unit"));
		lj.setExternal_scaffolding(rs.getString("external_scaffolding"));
		lj.setTower_crane_sum(rs.getString("tower_crane_sum"));
		lj.setPerson_ladder_sum(rs.getString("person_ladder_sum"));
		lj.setNacelle_num(rs.getString("nacelle_num"));
		lj.setWhether_pit(rs.getString("whether_pit"));
		lj.setImportant_project(rs.getString("important_project"));
		lj.setImage_schedule(rs.getString("image_schedule"));
		lj.setX_y(rs.getString("x_y"));
		return lj;
	}

}
